RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / www / admin / sqls /

Filename : v3_2_username_identifier.sql

back

ALTER TABLE users MODIFY `email` varchar(255) NULL;
ALTER TABLE users ADD COLUMN username VARCHAR(255) DEFAULT NULL AFTER profile_pic;
ALTER TABLE users ADD COLUMN created_by_type ENUM('SELF','ADMIN','PARENT') DEFAULT 'SELF' AFTER preferred_school_id;
ALTER TABLE users ADD COLUMN created_by_id INT DEFAULT NULL AFTER created_by_type;

ALTER TABLE group_members ADD COLUMN username VARCHAR(255) DEFAULT NULL AFTER email;
ALTER TABLE group_members MODIFY `email` varchar(255) DEFAULT NULL;